package cn.gok.oa.attendance.mapper;

import cn.gok.oa.attendance.dto.AttendanceDto;
import cn.gok.oa.attendance.entity.ExcelData;
import cn.gok.oa.attendance.entity.TbAttendance;
import cn.gok.oa.attendance.vo.AttendanceVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author gok
 * @since 2022-08-04
 */
@Mapper
public interface TbAttendanceMapper extends BaseMapper<TbAttendance> {
    public List<TbAttendance> queryByMonth(@Param("userId") int userId, @Param("month") int month);

    public List<AttendanceVo> getList(@Param("startTime") Date startTime, @Param("endTime") Date endTime, @Param("deptName") String deptName, @Param("status") Integer status);

    public List<AttendanceVo> excel();
}
